package com.seawaterbt.ssm.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.seawaterbt.ssm.config.DataSource;
import com.seawaterbt.ssm.config.DataSourceEnum;
import com.seawaterbt.ssm.entity.*;
import com.seawaterbt.ssm.mapper.ShengDatCrewDataMapper;
import com.seawaterbt.ssm.mapper.ShengDatRoomTempMapper;
import com.seawaterbt.ssm.service.CzBasHouseholdService;
import com.seawaterbt.ssm.service.CzDatRoomtempService;
import com.seawaterbt.ssm.service.ShengDatCrewDataService;
import com.seawaterbt.ssm.service.ShengDatRoomTempService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

/**
 * <p>
 * 服务实现类
 * </p>
 *
 * @author zhf
 * @since 2019-10-31
 */
@Service
public class ShengDatRoomTempServiceImpl extends ServiceImpl<ShengDatRoomTempMapper, ShengDatRoomTemp> implements ShengDatRoomTempService {
    DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

    @Autowired
    CzDatRoomtempService datRoomtempService;

    @Autowired
    CzBasHouseholdService basHouseholdService;

    @DataSource(DataSourceEnum.DB1)
    @Override
    public ShengDatRoomTemp getByCodeTime(QueryWrapper wrapper) {
        return this.getOne(wrapper);
    }

    @DataSource(DataSourceEnum.DB1)
    @Override
    public void sendData() {
        QueryWrapper<CzDatRoomtemp> queryWrapper = new QueryWrapper<>();
        queryWrapper.likeRight("household_code", 130981011).or().likeRight("household_code", 130903007);
        List<CzDatRoomtemp> datRoomtemp = datRoomtempService.list(queryWrapper);
        Date date = new Date();
        for (CzDatRoomtemp data : datRoomtemp) {
            BasHousehold one = basHouseholdService.listOne(data.getHouseholdCode());
            if (one != null && one.getRoomCodeProvince() != null && !one.getRoomCodeProvince().equals("")) {
                QueryWrapper wrapper = new QueryWrapper();
                wrapper.eq("HouseHoldID", one.getRoomCodeProvince());
                wrapper.eq("GetTime", data.getGetTime());
                ShengDatRoomTemp byCodeTime = getByCodeTime(wrapper);
                if (byCodeTime == null) {
                    ShengDatRoomTemp datData = new ShengDatRoomTemp();
                    datData.setHouseHoldId(one.getRoomCodeProvince());
                    datData.setAddTime(date);
                    datData.setGetTime(data.getGetTime());
                    datData.setRoomTemp(Double.valueOf(data.getRoomTemp()));
                    this.save(datData);
                }
            }
        }
        System.out.println("完成同步典型测温到中间库 " + df.format(new Date()));
    }

    @DataSource(DataSourceEnum.DB1)
    @Override
    public boolean save(ShengDatRoomTemp entity) {
        return super.save(entity);
    }

}
